package com.shsmi.hq.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.shsmi.hq.entity.DataHbjds;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.math.BigDecimal;
import java.util.List;

public interface DataHbjdsMapper extends BaseMapper<DataHbjds> {
    @Select("select qx_mc,pzswh,pzrq from data_hbjds where ST_Intersects(ST_PointFromText('POINT(${x} ${y})',st_srid(geom)),geom)=true limit 10")
    List<DataHbjds> listByPointIntersect(@Param("x") float x,@Param("y") float y);
}
